<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_users`;");
E_C("CREATE TABLE `ecs_users` (
  `user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `aite_id` text NOT NULL,
  `email` varchar(60) NOT NULL DEFAULT '',
  `user_name` varchar(60) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `is_surplus_open` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否开启余额支付密码功能',
  `surplus_password` varchar(32) NOT NULL COMMENT '余额支付密码',
  `question` varchar(255) NOT NULL DEFAULT '',
  `answer` varchar(255) NOT NULL DEFAULT '',
  `sex` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `birthday` date NOT NULL DEFAULT '0000-00-00',
  `user_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `frozen_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pay_points` int(10) unsigned NOT NULL DEFAULT '0',
  `rank_points` int(10) unsigned NOT NULL DEFAULT '0',
  `address_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `reg_time` int(10) unsigned NOT NULL DEFAULT '0',
  `last_login` int(11) unsigned NOT NULL DEFAULT '0',
  `last_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_ip` varchar(15) NOT NULL DEFAULT '',
  `visit_count` smallint(5) unsigned NOT NULL DEFAULT '0',
  `user_rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `is_special` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ec_salt` varchar(10) DEFAULT NULL,
  `salt` varchar(10) NOT NULL DEFAULT '0',
  `parent_id` mediumint(9) NOT NULL DEFAULT '0',
  `flag` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `alias` varchar(60) NOT NULL,
  `msn` varchar(60) NOT NULL,
  `qq` varchar(20) NOT NULL,
  `office_phone` varchar(20) NOT NULL,
  `home_phone` varchar(20) NOT NULL,
  `mobile_phone` varchar(20) NOT NULL,
  `is_validated` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `validated` int(11) NOT NULL,
  `credit_line` decimal(10,2) unsigned NOT NULL,
  `passwd_question` varchar(50) DEFAULT NULL,
  `passwd_answer` varchar(255) DEFAULT NULL,
  `is_fenxiao` tinyint(1) NOT NULL,
  `real_name` varchar(255) NOT NULL,
  `card` varchar(255) NOT NULL,
  `face_card` varchar(255) NOT NULL,
  `back_card` varchar(255) NOT NULL,
  `country` int(11) NOT NULL,
  `province` int(11) NOT NULL,
  `city` int(11) NOT NULL,
  `district` int(11) NOT NULL,
  `address` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `mediaUID` varchar(50) NOT NULL,
  `mediaID` int(4) NOT NULL,
  `froms` char(10) NOT NULL DEFAULT 'pc' COMMENT 'pc:电脑,mobile:手机,app:应用',
  `headimg` varchar(255) NOT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  KEY `email` (`email`),
  KEY `parent_id` (`parent_id`),
  KEY `flag` (`flag`),
  KEY `mediaUID` (`mediaUID`,`mediaID`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_users` values('1','','anan@hongyuvip.com','anan','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','99990.00','110.00','0','0','16','1437431243','1443474022','0000-00-00 00:00:00','110.211.206.143','3205','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('2','','285188787@qq.com','68ecshopyy','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','100','15','1437497947','1443484111','0000-00-00 00:00:00','219.154.200.177','18','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','data/headimg/201507/1437497989600204049.jpg');");
E_D("replace into `ecs_users` values('3','','admin9@qq.com','admin9','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','100','0','1437500502','1437500519','0000-00-00 00:00:00','192.168.1.196','2','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('4','','admin8@qq.com','admin8','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','100','0','1437501016','1437501016','0000-00-00 00:00:00','192.168.1.196','1','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('5','','2691111111@qq.com','leilei','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','100','1','1437502269','1437947273','0000-00-00 00:00:00','192.168.1.162','7','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('6','','3490134@qq.com','yiren','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','100','0','1437503705','1437593672','0000-00-00 00:00:00','192.168.1.146','3','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('7','','33342@qq.com','liuyu','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','100','0','1437518661','1437520761','0000-00-00 00:00:00','192.168.1.125','2','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('8','','222222@qq.com','liza','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','100','0','1437525999','1437525999','0000-00-00 00:00:00','192.168.1.162','1','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('10','','2326932886@qq.com','68ECSHOP','e10adc3949ba59abbe56e057f20f883e','0','','','','2','1955-01-01','2.00','0.00','10496','10396','19','1443382316','1443576206','0000-00-00 00:00:00','120.6.73.84','1195','0','0','0','0','0','0','','','','','','','1','0','0.00','','','0','','','images/201509/1443556222463600538.png','','0','0','0','0','','0','','0','pc','data/headimg/201509/1443556079008548860.png');");
E_D("replace into `ecs_users` values('11','','zhaoyunlong@hongyuvip.com','Lsay','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1958-05-05','4746.00','0.00','100','100','18','1443382587','1443549501','0000-00-00 00:00:00','120.6.73.84','4019','0','0','0','0','0','0','','','','','','','1','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','data/headimg/201509/1443382633057843332.jpg');");
E_D("replace into `ecs_users` values('12','','liuxiaona@hongyuvip.com','Lxn','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','896.00','0.00','199','199','17','1443382656','1443393829','0000-00-00 00:00:00','120.6.73.84','1181','0','0','0','0','0','0','','','','','','','1','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('14','','abc@123.com','testadmin','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','1000000.00','0.00','0','0','22','1443487206','1443553777','0000-00-00 00:00:00','113.91.7.47','2','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','1','','0','pc','');");
E_D("replace into `ecs_users` values('13','','yuchun09@126.com','u855UNRP6535','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','100','0','1443462703','1443462703','0000-00-00 00:00:00','110.185.4.253','1','0','0','0','0','0','0','','','','','','','1','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('15','','2532975042@qq.com','zzy','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','0','0','1443528677','1443528745','0000-00-00 00:00:00','58.38.5.199','1','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','0','','0','app','');");
E_D("replace into `ecs_users` values('16','','2006longmen@163.com','u909XMJA6281','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','100','0','1443557593','1443557593','0000-00-00 00:00:00','61.146.224.157','1','0','0','0','0','0','0','','','','','','','1','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('17','','89576867@qq.com','u825KRQ1964','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','100','0','1443563163','1443563163','0000-00-00 00:00:00','111.37.29.58','1','0','0','0','0','0','0','','','','','','','1','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('18','','3@e.com','ceshi','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','0','0','0','1443563772','1443578712','0000-00-00 00:00:00','116.26.209.184','3','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','1','','0','pc','');");
E_D("replace into `ecs_users` values('19','','1111@1111.1111','111','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','0','0','0','1443568756','1443586365','0000-00-00 00:00:00','115.60.17.181','32','0','0','0','0','0','0','','','','','','','0','0','0.00','','','0','','','','','0','0','0','0','','1','','0','pc','');");
E_D("replace into `ecs_users` values('20','','903682097@qq.com','u156CZJL7391','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','100','100','0','1443572460','1443572460','0000-00-00 00:00:00','61.146.224.157','1','0','0','0','0','0','0','','','','','','','1','0','0.00','','','0','','','','','0','0','0','0','','0','','0','pc','');");
E_D("replace into `ecs_users` values('21','','xtony@126.com','u223RLXK7008','e10adc3949ba59abbe56e057f20f883e','0','','','','0','1955-01-01','0.00','0.00','7','7','24','1443573060','1443576843','0000-00-00 00:00:00','120.236.229.82','186','0','0','0','0','0','0','','','','','','','1','0','0.00','','','0','','','','','0','0','0','0','','0','','0','mobile','');");
E_D("replace into `ecs_users` values('22','','test@163.com','test','07b5cceb05961a91fc8746a395913ad1','0','','','','0','1955-01-01','999999.00','0.00','7','7','25','1443585455','1446351861','0000-00-00 00:00:00','0.0.0.0','95','0','0','3187','0','0','0','','','','','','13800138000','0','0','0.00','','','0','','','','','0','0','0','0','','0','','0','mobile','');");
E_D("replace into `ecs_users` values('23','','shop@admin.com','shop','223be6aa7362e9a04053ac90f0e4be03','0','','','','0','1955-01-01','0.00','0.00','100','100','0','1443598212','1446348688','0000-00-00 00:00:00','0.0.0.0','2','0','0','4514','0','0','0','','','','','','','1','0','0.00','','','0','','','','','0','0','0','0','','1','','0','pc','');");

require("../../inc/footer.php");
?>